Development of a Business Intelligence Conceptual Model for Waste Collection and Transportation Monitoring

Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceThe need to answer ever-increasing urban challenges and the integration of new technologies in every aspect of our daily lives prompt the creation of the Smart City concept. These new technologies gather an enormous quantity of data that reveals interesting patterns about cities, enabling opportunities to enhance public decision-making and problem-solving. One critical aspect of urban life is its relationship with the environment. There’s a real need to work on a unified global approach on how to tackle issues such as pollution and waste management, but there is not a single framework or guideline to handle these new data gathered. This work focuses on structuring a framework of analysis for waste collection and transportation purposes. The objective was to develop monitoring dashboards for Departamento de Higienização Urbana (DMHU), using proven metrics of efficiency and effectiveness, result of a comprehensive literature review. A BI framework was developed using Power BI to perform efficiency-based analysis of waste collection circuits – the main process of DMHU. The receptivity of DMHU towards the solution presented seems to indicate that a BI solution is indeed valuable for complex monitoring problems such as solid waste management